﻿CREATE TABLE [dbo].[MijloaceTransport] (
    [IDMijlocTransport] SMALLINT      IDENTITY (1, 1) NOT NULL,
    [Denumire]          VARCHAR (150) NOT NULL,
    [NrInmatriculare]   VARCHAR (50)  NOT NULL,
    [IDPartener]        BIGINT        NOT NULL,
    CONSTRAINT [PK_MijloaceTransport] PRIMARY KEY CLUSTERED ([IDMijlocTransport] ASC),
    CONSTRAINT [FK_MijloaceTransport_Parteneri] FOREIGN KEY ([IDPartener]) REFERENCES [dbo].[Parteneri] ([IDPartener])
);

